/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50634
Source Host           : localhost:3306
Source Database       : actmanage

Target Server Type    : MYSQL
Target Server Version : 50634
File Encoding         : 65001

Date: 2017-10-20 13:43:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_attendance_management
-- ----------------------------
DROP TABLE IF EXISTS `t_attendance_management`;
CREATE TABLE `t_attendance_management` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`evaluation_id`  int(255) NULL DEFAULT NULL COMMENT '员工id' ,
`date`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考勤当日' ,
`month`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '月份' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=8

;

-- ----------------------------
-- Records of t_attendance_management
-- ----------------------------
BEGIN;
INSERT INTO `t_attendance_management` VALUES ('1', '1', '2011-11-11', '2'), ('2', '0', null, null), ('3', '0', null, null), ('4', '0', null, null), ('5', '0', null, null), ('6', '0', null, null), ('7', '1', '2', '3');
COMMIT;

-- ----------------------------
-- Table structure for t_customs_management
-- ----------------------------
DROP TABLE IF EXISTS `t_customs_management`;
CREATE TABLE `t_customs_management` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`date`  datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '日期' ,
`type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '费用类型 (1:xx,2:xx等）' ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '费用名目' ,
`payee`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收款单位' ,
`payerId`  int(255) NULL DEFAULT NULL COMMENT '付款人' ,
`money`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '金额' ,
`charge`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '剩余金额' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=27

;

-- ----------------------------
-- Records of t_customs_management
-- ----------------------------
BEGIN;
INSERT INTO `t_customs_management` VALUES ('1', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('2', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('3', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('4', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('5', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('6', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('7', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('8', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('9', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('10', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('11', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('12', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('13', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('14', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('15', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('16', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('17', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('18', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('19', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('20', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('21', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('22', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('23', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('24', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('25', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6'), ('26', '2017-10-19 16:56:03', '1', '办公用品', '3', '4', '5000', '6');
COMMIT;

-- ----------------------------
-- Table structure for t_employee
-- ----------------------------
DROP TABLE IF EXISTS `t_employee`;
CREATE TABLE `t_employee` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`employee_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工号' ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓名' ,
`sex`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '性别' ,
`place_of_birth`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '出生地' ,
`date_of_birth`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '出生日期' ,
`phone`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式' ,
`photo`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片' ,
`state`  int(255) NULL DEFAULT NULL COMMENT '离职或者在职0:离职1:在职' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=13

;

-- ----------------------------
-- Records of t_employee
-- ----------------------------
BEGIN;
INSERT INTO `t_employee` VALUES ('1', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('2', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('3', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('4', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('5', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('6', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('7', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('8', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('9', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('10', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('11', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1'), ('12', 'act_01', '小明', '1', '北京', '2011-11-11', '13888888888', '头像1', '1');
COMMIT;

-- ----------------------------
-- Table structure for t_performance_evaluation
-- ----------------------------
DROP TABLE IF EXISTS `t_performance_evaluation`;
CREATE TABLE `t_performance_evaluation` (
`id`  int(255) NOT NULL AUTO_INCREMENT ,
`employee_id`  int(11) NULL DEFAULT NULL COMMENT '员工id' ,
`communication_user`  int(11) NULL DEFAULT NULL COMMENT '参与沟通人' ,
`performance_date`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '绩效期间' ,
`communication_date`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '沟通日期' ,
`goal_type`  int(255) NULL DEFAULT NULL COMMENT '发展目标类型0：个人 1：组织' ,
`self_review`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自我回顾' ,
`evaluat`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评价与建议' ,
`record_type`  int(11) NULL DEFAULT NULL COMMENT '记录:1:奖励 2惩处' ,
`ways_of_cashing`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '兑现方式' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=15

;

-- ----------------------------
-- Records of t_performance_evaluation
-- ----------------------------
BEGIN;
INSERT INTO `t_performance_evaluation` VALUES ('1', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('2', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('3', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('4', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('5', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('6', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('7', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('8', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('9', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('10', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('11', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('12', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('13', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式'), ('14', '1', '2', '2011-11-11-2012-11-11', '2011-12-12', '1', '自我回顾自我回顾', null, '1', '兑现方式');
COMMIT;

-- ----------------------------
-- Auto increment value for t_attendance_management
-- ----------------------------
ALTER TABLE `t_attendance_management` AUTO_INCREMENT=8;

-- ----------------------------
-- Auto increment value for t_customs_management
-- ----------------------------
ALTER TABLE `t_customs_management` AUTO_INCREMENT=27;

-- ----------------------------
-- Auto increment value for t_employee
-- ----------------------------
ALTER TABLE `t_employee` AUTO_INCREMENT=13;

-- ----------------------------
-- Auto increment value for t_performance_evaluation
-- ----------------------------
ALTER TABLE `t_performance_evaluation` AUTO_INCREMENT=15;
